{ "cells": [ { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "# Downloading CAISO Oasis Datasets\n", "\n", "Grid Status provides access to many CAISO OASIS datasets. If one is missing, please post an issue on GitHub and we will add it" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import gridstatus\n", "\n", "iso = gridstatus.CAISO()\n", "# autoreload\n", "%load_ext autoreload\n", "%autoreload 2" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "List All Available Oasis Datasets" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Dataset: transmission_interface_usage\n", "+---------------+-----------+-------------------+\n", "| Parameter | Default | Possible Values |\n", "+===============+===========+===================+\n", "| market_run_id | DAM | DAM, HASP, RRPD |\n", "+---------------+-----------+-------------------+\n", "| ti_id | ALL | N/A |\n", "+---------------+-----------+-------------------+\n", "| ti_direction | ALL | ALL, E, I |\n", "+---------------+-----------+-------------------+\n", "\n", "\n", "Dataset: schedule_by_tie\n", "+-------------+------------------------+-------------------------------------------------------------------------------------------------+\n", "| Parameter | Default | Possible Values |\n", "+=============+========================+=================================================================================================+\n", "| groupid | RTD_ENE_SCH_BY_TIE_GRP | RTD_ENE_SCH_BY_TIE_GRP, DAM_ENE_SCH_BY_TIE_GRP, RUC_ENE_SCH_BY_TIE_GRP, RTPD_ENE_SCH_BY_TIE_GRP |\n", "+-------------+------------------------+-------------------------------------------------------------------------------------------------+\n", "\n", "\n", "Dataset: as_requirements\n", "+---------------+-----------+---------------------+\n", "| Parameter | Default | Possible Values |\n", "+===============+===========+=====================+\n", "| market_run_id | DAM | DAM, HASP, RTM, 2DA |\n", "+---------------+-----------+---------------------+\n", "| anc_type | ALL | N/A |\n", "+---------------+-----------+---------------------+\n", "| anc_region | ALL | N/A |\n", "+---------------+-----------+---------------------+\n", "\n", "\n", "Dataset: as_clearing_prices\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "| Parameter | Default | Possible Values |\n", "+===============+===========+=========================================================================+\n", "| market_run_id | DAM | DAM, HASP |\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "| anc_type | ALL | ALL, NR, RD, RMD, RMU, RU, SR |\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "| anc_region | ALL | ALL, AS_CAISO, AS_SP26_EXP, AS_SP26, AS_CAISO_EXP, AS_NP26_EXP, AS_NP26 |\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "\n", "\n", "Dataset: fuel_prices\n", "+----------------+-----------+-------------------+\n", "| Parameter | Default | Possible Values |\n", "+================+===========+===================+\n", "| fuel_region_id | ALL | N/A |\n", "+----------------+-----------+-------------------+\n", "\n", "\n", "Dataset: ghg_allowances\n", " No parameters\n", "\n", "\n", "Dataset: wind_and_solar_forecast\n", " No parameters\n", "\n", "\n" ] } ], "source": [ "iso.list_oasis_datasets()" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "Get Data for specific dataset and set of parameters" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Dataset: as_clearing_prices\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "| Parameter | Default | Possible Values |\n", "+===============+===========+=========================================================================+\n", "| market_run_id | DAM | DAM, HASP |\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "| anc_type | ALL | ALL, NR, RD, RMD, RMU, RU, SR |\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "| anc_region | ALL | ALL, AS_CAISO, AS_SP26_EXP, AS_SP26, AS_CAISO_EXP, AS_NP26_EXP, AS_NP26 |\n", "+---------------+-----------+-------------------------------------------------------------------------+\n", "\n", "\n" ] } ], "source": [ "iso.list_oasis_datasets(\"as_clearing_prices\")" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
INTERVALSTARTTIME_GMTINTERVALENDTIME_GMTOPR_DTOPR_HROPR_INTERVALOPR_TYPEANC_TYPEANC_REGIONMARKET_RUN_IDXML_DATA_ITEMMWGROUP
02023-04-21T13:00:00-00:002023-04-21T14:00:00-00:002023-04-2170HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
12023-04-22T05:00:00-00:002023-04-22T06:00:00-00:002023-04-21230HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
22023-04-22T04:00:00-00:002023-04-22T05:00:00-00:002023-04-21220HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
32023-04-21T08:00:00-00:002023-04-21T09:00:00-00:002023-04-2120HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
42023-04-21T23:00:00-00:002023-04-22T00:00:00-00:002023-04-21170HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
52023-04-22T02:00:00-00:002023-04-22T03:00:00-00:002023-04-21200HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
62023-04-21T18:00:00-00:002023-04-21T19:00:00-00:002023-04-21120HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
72023-04-22T03:00:00-00:002023-04-22T04:00:00-00:002023-04-21210HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
82023-04-21T11:00:00-00:002023-04-21T12:00:00-00:002023-04-2150HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
92023-04-21T16:00:00-00:002023-04-21T17:00:00-00:002023-04-21100HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
102023-04-22T06:00:00-00:002023-04-22T07:00:00-00:002023-04-21240HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
112023-04-21T10:00:00-00:002023-04-21T11:00:00-00:002023-04-2140HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
122023-04-21T12:00:00-00:002023-04-21T13:00:00-00:002023-04-2160HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
132023-04-21T14:00:00-00:002023-04-21T15:00:00-00:002023-04-2180HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
142023-04-21T15:00:00-00:002023-04-21T16:00:00-00:002023-04-2190HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
152023-04-21T22:00:00-00:002023-04-21T23:00:00-00:002023-04-21160HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
162023-04-21T19:00:00-00:002023-04-21T20:00:00-00:002023-04-21130HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
172023-04-22T00:00:00-00:002023-04-22T01:00:00-00:002023-04-21180HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
182023-04-22T01:00:00-00:002023-04-22T02:00:00-00:002023-04-21190HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
192023-04-21T07:00:00-00:002023-04-21T08:00:00-00:002023-04-2110HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
202023-04-21T09:00:00-00:002023-04-21T10:00:00-00:002023-04-2130HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
212023-04-21T17:00:00-00:002023-04-21T18:00:00-00:002023-04-21110HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
222023-04-21T20:00:00-00:002023-04-21T21:00:00-00:002023-04-21140HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
232023-04-21T21:00:00-00:002023-04-21T22:00:00-00:002023-04-21150HourlyRMUAS_CAISO_EXPDAMRMU_CLR_PRC01
\n", "
" ], "text/plain": [ " INTERVALSTARTTIME_GMT INTERVALENDTIME_GMT OPR_DT OPR_HR \\\n", "0 2023-04-21T13:00:00-00:00 2023-04-21T14:00:00-00:00 2023-04-21 7 \n", "1 2023-04-22T05:00:00-00:00 2023-04-22T06:00:00-00:00 2023-04-21 23 \n", "2 2023-04-22T04:00:00-00:00 2023-04-22T05:00:00-00:00 2023-04-21 22 \n", "3 2023-04-21T08:00:00-00:00 2023-04-21T09:00:00-00:00 2023-04-21 2 \n", "4 2023-04-21T23:00:00-00:00 2023-04-22T00:00:00-00:00 2023-04-21 17 \n", "5 2023-04-22T02:00:00-00:00 2023-04-22T03:00:00-00:00 2023-04-21 20 \n", "6 2023-04-21T18:00:00-00:00 2023-04-21T19:00:00-00:00 2023-04-21 12 \n", "7 2023-04-22T03:00:00-00:00 2023-04-22T04:00:00-00:00 2023-04-21 21 \n", "8 2023-04-21T11:00:00-00:00 2023-04-21T12:00:00-00:00 2023-04-21 5 \n", "9 2023-04-21T16:00:00-00:00 2023-04-21T17:00:00-00:00 2023-04-21 10 \n", "10 2023-04-22T06:00:00-00:00 2023-04-22T07:00:00-00:00 2023-04-21 24 \n", "11 2023-04-21T10:00:00-00:00 2023-04-21T11:00:00-00:00 2023-04-21 4 \n", "12 2023-04-21T12:00:00-00:00 2023-04-21T13:00:00-00:00 2023-04-21 6 \n", "13 2023-04-21T14:00:00-00:00 2023-04-21T15:00:00-00:00 2023-04-21 8 \n", "14 2023-04-21T15:00:00-00:00 2023-04-21T16:00:00-00:00 2023-04-21 9 \n", "15 2023-04-21T22:00:00-00:00 2023-04-21T23:00:00-00:00 2023-04-21 16 \n", "16 2023-04-21T19:00:00-00:00 2023-04-21T20:00:00-00:00 2023-04-21 13 \n", "17 2023-04-22T00:00:00-00:00 2023-04-22T01:00:00-00:00 2023-04-21 18 \n", "18 2023-04-22T01:00:00-00:00 2023-04-22T02:00:00-00:00 2023-04-21 19 \n", "19 2023-04-21T07:00:00-00:00 2023-04-21T08:00:00-00:00 2023-04-21 1 \n", "20 2023-04-21T09:00:00-00:00 2023-04-21T10:00:00-00:00 2023-04-21 3 \n", "21 2023-04-21T17:00:00-00:00 2023-04-21T18:00:00-00:00 2023-04-21 11 \n", "22 2023-04-21T20:00:00-00:00 2023-04-21T21:00:00-00:00 2023-04-21 14 \n", "23 2023-04-21T21:00:00-00:00 2023-04-21T22:00:00-00:00 2023-04-21 15 \n", "\n", " OPR_INTERVAL OPR_TYPE ANC_TYPE ANC_REGION MARKET_RUN_ID XML_DATA_ITEM \\\n", "0 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "1 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "2 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "3 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "4 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "5 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "6 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "7 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "8 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "9 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "10 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "11 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "12 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "13 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "14 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "15 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "16 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "17 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "18 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "19 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "20 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "21 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "22 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "23 0 Hourly RMU AS_CAISO_EXP DAM RMU_CLR_PRC \n", "\n", " MW GROUP \n", "0 0 1 \n", "1 0 1 \n", "2 0 1 \n", "3 0 1 \n", "4 0 1 \n", "5 0 1 \n", "6 0 1 \n", "7 0 1 \n", "8 0 1 \n", "9 0 1 \n", "10 0 1 \n", "11 0 1 \n", "12 0 1 \n", "13 0 1 \n", "14 0 1 \n", "15 0 1 \n", "16 0 1 \n", "17 0 1 \n", "18 0 1 \n", "19 0 1 \n", "20 0 1 \n", "21 0 1 \n", "22 0 1 \n", "23 0 1 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = iso.get_oasis_dataset(\n", " dataset=\"as_clearing_prices\",\n", " params={\n", " \"market_run_id\": \"DAM\",\n", " \"anc_type\": \"RMU\",\n", " \"anc_region\": \"AS_CAISO_EXP\",\n", " },\n", " date=\"today\",\n", ")\n", "df" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "Query for Date Range" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Dataset: as_requirements\n", "+---------------+-----------+---------------------+\n", "| Parameter | Default | Possible Values |\n", "+===============+===========+=====================+\n", "| market_run_id | DAM | DAM, HASP, RTM, 2DA |\n", "+---------------+-----------+---------------------+\n", "| anc_type | ALL | N/A |\n", "+---------------+-----------+---------------------+\n", "| anc_region | ALL | N/A |\n", "+---------------+-----------+---------------------+\n", "\n", "\n" ] } ], "source": [ "iso.list_oasis_datasets(\"as_requirements\")" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
POSMARKET_RUN_IDANC_TYPEANC_REGIONLABELXML_DATA_ITEMMWINTERVALSTARTTIME_GMTINTERVALENDTIME_GMTOPR_DTOPR_HROPR_INTERVALGROUP
05DAMNRAS_CAISOAS Regional AS Requirement MaximumNS_REQ_MAX_MW0.002023-04-01T21:00:00-00:002023-04-01T22:00:00-00:002023-04-011501
15DAMNRAS_CAISOAS Regional AS Requirement MaximumNS_REQ_MAX_MW0.002023-04-01T09:00:00-00:002023-04-01T10:00:00-00:002023-04-01301
25DAMNRAS_CAISOAS Regional AS Requirement MaximumNS_REQ_MAX_MW0.002023-04-01T16:00:00-00:002023-04-01T17:00:00-00:002023-04-011001
35DAMNRAS_CAISOAS Regional AS Requirement MaximumNS_REQ_MAX_MW0.002023-04-01T10:00:00-00:002023-04-01T11:00:00-00:002023-04-01401
45DAMNRAS_CAISOAS Regional AS Requirement MaximumNS_REQ_MAX_MW0.002023-04-02T02:00:00-00:002023-04-02T03:00:00-00:002023-04-012001
..........................................
249554DAMSRAS_SP26_EXPAS Regional AS Requirement MinimumSP_REQ_MIN_MW93.542023-04-20T07:00:00-00:002023-04-20T08:00:00-00:002023-04-20101040
249564DAMSRAS_SP26_EXPAS Regional AS Requirement MinimumSP_REQ_MIN_MW143.192023-04-20T18:00:00-00:002023-04-20T19:00:00-00:002023-04-201201040
249574DAMSRAS_SP26_EXPAS Regional AS Requirement MinimumSP_REQ_MIN_MW102.522023-04-21T05:00:00-00:002023-04-21T06:00:00-00:002023-04-202301040
249584DAMSRAS_SP26_EXPAS Regional AS Requirement MinimumSP_REQ_MIN_MW123.882023-04-20T23:00:00-00:002023-04-21T00:00:00-00:002023-04-201701040
249594DAMSRAS_SP26_EXPAS Regional AS Requirement MinimumSP_REQ_MIN_MW103.252023-04-20T14:00:00-00:002023-04-20T15:00:00-00:002023-04-20801040
\n", "

24960 rows × 13 columns

\n", "
" ], "text/plain": [ " POS MARKET_RUN_ID ANC_TYPE ANC_REGION \\\n", "0 5 DAM NR AS_CAISO \n", "1 5 DAM NR AS_CAISO \n", "2 5 DAM NR AS_CAISO \n", "3 5 DAM NR AS_CAISO \n", "4 5 DAM NR AS_CAISO \n", "... ... ... ... ... \n", "24955 4 DAM SR AS_SP26_EXP \n", "24956 4 DAM SR AS_SP26_EXP \n", "24957 4 DAM SR AS_SP26_EXP \n", "24958 4 DAM SR AS_SP26_EXP \n", "24959 4 DAM SR AS_SP26_EXP \n", "\n", " LABEL XML_DATA_ITEM MW \\\n", "0 AS Regional AS Requirement Maximum NS_REQ_MAX_MW 0.00 \n", "1 AS Regional AS Requirement Maximum NS_REQ_MAX_MW 0.00 \n", "2 AS Regional AS Requirement Maximum NS_REQ_MAX_MW 0.00 \n", "3 AS Regional AS Requirement Maximum NS_REQ_MAX_MW 0.00 \n", "4 AS Regional AS Requirement Maximum NS_REQ_MAX_MW 0.00 \n", "... ... ... ... \n", "24955 AS Regional AS Requirement Minimum SP_REQ_MIN_MW 93.54 \n", "24956 AS Regional AS Requirement Minimum SP_REQ_MIN_MW 143.19 \n", "24957 AS Regional AS Requirement Minimum SP_REQ_MIN_MW 102.52 \n", "24958 AS Regional AS Requirement Minimum SP_REQ_MIN_MW 123.88 \n", "24959 AS Regional AS Requirement Minimum SP_REQ_MIN_MW 103.25 \n", "\n", " INTERVALSTARTTIME_GMT INTERVALENDTIME_GMT OPR_DT \\\n", "0 2023-04-01T21:00:00-00:00 2023-04-01T22:00:00-00:00 2023-04-01 \n", "1 2023-04-01T09:00:00-00:00 2023-04-01T10:00:00-00:00 2023-04-01 \n", "2 2023-04-01T16:00:00-00:00 2023-04-01T17:00:00-00:00 2023-04-01 \n", "3 2023-04-01T10:00:00-00:00 2023-04-01T11:00:00-00:00 2023-04-01 \n", "4 2023-04-02T02:00:00-00:00 2023-04-02T03:00:00-00:00 2023-04-01 \n", "... ... ... ... \n", "24955 2023-04-20T07:00:00-00:00 2023-04-20T08:00:00-00:00 2023-04-20 \n", "24956 2023-04-20T18:00:00-00:00 2023-04-20T19:00:00-00:00 2023-04-20 \n", "24957 2023-04-21T05:00:00-00:00 2023-04-21T06:00:00-00:00 2023-04-20 \n", "24958 2023-04-20T23:00:00-00:00 2023-04-21T00:00:00-00:00 2023-04-20 \n", "24959 2023-04-20T14:00:00-00:00 2023-04-20T15:00:00-00:00 2023-04-20 \n", "\n", " OPR_HR OPR_INTERVAL GROUP \n", "0 15 0 1 \n", "1 3 0 1 \n", "2 10 0 1 \n", "3 4 0 1 \n", "4 20 0 1 \n", "... ... ... ... \n", "24955 1 0 1040 \n", "24956 12 0 1040 \n", "24957 23 0 1040 \n", "24958 17 0 1040 \n", "24959 8 0 1040 \n", "\n", "[24960 rows x 13 columns]" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = iso.get_oasis_dataset(\n", " dataset=\"as_requirements\",\n", " params={\n", " \"market_run_id\": \"DAM\",\n", " },\n", " start=\"2023-04-01\",\n", " end=\"2023-04-21\",\n", ")\n", "df" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.10.2" }, "orig_nbformat": 4, "vscode": { "interpreter": { "hash": "49f14642123d0cc1afa9fa45716ed5f1e915189c28b01efe02a8b7ec3c0a3fce" } } }, "nbformat": 4, "nbformat_minor": 2 }